USE HierarchyIdDemo
GO

-- moving department in SelfJoin.Org table
EXEC SelfJoin.ShowDepartmentChart 1

-- move parking to part of
-- home operations
	UPDATE SelfJoin.Org
			SET ParentID = 5
		WHERE DepartmentID = 4

EXEC SelfJoin.ShowDepartmentChart 1